OpenBots command for connecting to and executing queries against a database. Supports OLE DB.
OpenBots.Commands.Database \ Execute Database Stored Procedure Command
This command performs a OleDb database query.
Database Instance Name
Enter the unique instance that was specified in the **Define Database Connection** command.
Required
Stored Procedure
Define the OleDb stored procedure to execute.
Required
Timeout (Seconds)
Specify how many seconds to wait before throwing an exception.
Required
Output Affected Row Count Variable (Optional)
Create a new variable or select a variable from the list.
Output Parameter Dictionary Variable (Optional)
Create a new variable or select a variable from the list.
Private (Optional)
Optional field to mark the command as private (data sensitive) in order to avoid its logging.
Remote (Optional)
Optional field to mark the command as remote in order to execute it on a remote machine.
Error Handling
Optional field for how to handle errors encountered.
Required
Comment (Optional)
Optional field to enter a custom comment which could potentially describe this command or the need for this command.